﻿USE [DBDDCUsers]
GO
INSERT [dbo].[Applications] ([ApplicationName], [ApplicationId], [Description]) VALUES (N'/', N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', NULL)
GO
INSERT [dbo].[Users] ([ApplicationId], [UserId], [UserName], [IsAnonymous], [LastActivityDate]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'ab898831-901d-4cf8-ae8f-a54a7dbd20ce', N'SuperAdmin', 0, CAST(0x0000A45F0028213D AS DateTime))
GO
INSERT [dbo].[Users] ([ApplicationId], [UserId], [UserName], [IsAnonymous], [LastActivityDate]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'fd9a36a5-0817-4b4c-a3a3-b1df5fe22a0f', N'Admin', 0, CAST(0x0000A45D0054AF13 AS DateTime))
GO
INSERT [dbo].[Memberships] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [Email], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowsStart], [Comment]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'ab898831-901d-4cf8-ae8f-a54a7dbd20ce', N'NZUsMUvYc0D/DW6thxlBggU6kbm+m9WFDYX/cIJzVFw=', 1, N'AUwoNHaNzUNdw4fv0Yvg2A==', N'superadmin@admin.com', NULL, NULL, 1, 0, CAST(0x0000A45B001A41CB AS DateTime), CAST(0x0000A45F0028213D AS DateTime), CAST(0x0000A45B001A41CB AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), NULL)
GO
INSERT [dbo].[Memberships] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [Email], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowsStart], [Comment]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'fd9a36a5-0817-4b4c-a3a3-b1df5fe22a0f', N'WL1KrrEYpToXwJGBE1+CPUbCTX8Nm159zGS4Rf2BSik=', 1, N'pvwzmCtvaAl3mYeIzFDINw==', N'admin@admin.com', NULL, NULL, 1, 0, CAST(0x0000A454012ACCB2 AS DateTime), CAST(0x0000A45D0054AF13 AS DateTime), CAST(0x0000A454012ACCB2 AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'd85ead72-7cd2-4b55-a5c2-028d68d22287', N'Admin', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'64bf2863-d9f4-4e0e-9930-1872fbc7eb92', N'Comunicaciones', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'29dd5db8-47b9-4c04-8106-1ff2a0c5d3b0', N'Promotor', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'c6e3ca70-5683-4cab-8828-223e8bc9edc4', N'SuperAdmin', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'e8c6c4ac-1c48-442c-8efa-37db303af462', N'Legal', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'2d19f056-c096-42fa-81dc-3d5b3305e025', N'Secretaría', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'4bdf8dc0-a148-49e1-bc42-45297cbfbaab', N'Voluntario', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'33dbfca7-bcfd-4978-a47a-49e75601c23d', N'Promoción de la Cultura', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'0a506266-c38a-449e-ab72-5090864849fc', N'Jefe de Área', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'c1d15ec0-5949-478b-8921-575fc8fecf6c', N'Arqueología', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'4939c96f-6d0d-4a68-9545-8962044dd9bc', N'Museos - Registro', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'575f5d7a-d716-40a8-b1c9-b6117fa51b0b', N'Administración', NULL)
GO
INSERT [dbo].[Roles] ([ApplicationId], [RoleId], [RoleName], [Description]) VALUES (N'd748b33e-9ac5-4fdd-b9ff-4946994e7621', N'3263b6bf-cd35-45a4-ad6c-f93a32519bd2', N'Arquitectura', NULL)
GO
INSERT [dbo].[UsersInRoles] ([UserId], [RoleId]) VALUES (N'ab898831-901d-4cf8-ae8f-a54a7dbd20ce', N'd85ead72-7cd2-4b55-a5c2-028d68d22287')
GO
INSERT [dbo].[UsersInRoles] ([UserId], [RoleId]) VALUES (N'ab898831-901d-4cf8-ae8f-a54a7dbd20ce', N'c6e3ca70-5683-4cab-8828-223e8bc9edc4')
GO
INSERT [dbo].[UsersInRoles] ([UserId], [RoleId]) VALUES (N'fd9a36a5-0817-4b4c-a3a3-b1df5fe22a0f', N'd85ead72-7cd2-4b55-a5c2-028d68d22287')
GO
INSERT [dbo].[Profiles] ([UserId], [PropertyNames], [PropertyValueStrings], [PropertyValueBinary], [LastUpdatedDate]) VALUES (N'ab898831-901d-4cf8-ae8f-a54a7dbd20ce', N'edad:0:1:appNombres:1:10:FechaNacimiento:11:10:dni:21:6:', N'0SuperAdmin01/01/2015000000', 0x, CAST(0x0000A45B001DCC91 AS DateTime))
GO
INSERT [dbo].[Profiles] ([UserId], [PropertyNames], [PropertyValueStrings], [PropertyValueBinary], [LastUpdatedDate]) VALUES (N'fd9a36a5-0817-4b4c-a3a3-b1df5fe22a0f', N'edad:0:2:appNombres:2:5:FechaNacimiento:7:10:dni:17:6:', N'00Admin01/01/2015000000', 0x, CAST(0x0000A45B001DA56B AS DateTime))
GO
